﻿CREATE TABLE [Core].[BusinessUnit] (
    [BusinessUnitId]   UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [DomainId]         UNIQUEIDENTIFIER NOT NULL,
    [BusinessUnitName] NVARCHAR (127)   NOT NULL,
    [Phone]            NVARCHAR (15)    NOT NULL,
    [Fax]              NVARCHAR (15)    NULL,
    [Email]            NVARCHAR (127)   NOT NULL,
    [MainAddressId]    UNIQUEIDENTIFIER NOT NULL,
    [IsDroppedYN]      NCHAR (1)        NOT NULL,
    [CreateDT]         DATETIME         NOT NULL,
    [CreatedById]      UNIQUEIDENTIFIER NOT NULL,
    [CreatedByName]    NVARCHAR (127)   NOT NULL,
    [ModifiedDT]       DATETIME         NOT NULL,
    [ModifiedById]     UNIQUEIDENTIFIER NOT NULL,
    [ModifiedByName]   NVARCHAR (127)   NOT NULL
);

